create database - Docs search results , p.3

Chapter 50. System Catalogs

CREATE DATABASE inserts a row into the pg_database catalog — and actually creates the database

ALTER DATABASE

DATABASE statement is a PostgreSQL extension. See Also CREATE DATABASE , DROP DATABASE , SET , CREATE TABLESPACE

Appendix F. Additional Supplied Modules

CREATE EXTENSION command. In a fresh database, you can simply do CREATE EXTENSION module_name

25.1. SQL Dump

database dbname will not be created by this command, so you must create it yourself

31.1. Running the Tests

create a database called regression on the primary: psql -h primary -c "CREATE DATABASE regression

Chapter 44. PL/Python - Python Procedural Language

database, use CREATE EXTENSION plpythonu , or from the shell command line use createlang plpythonu dbname

5.8. Schemas

database you are connected to. So to create a table in the new schema, use: CREATE

19.15. Preset Options

database is created. lc_ctype ( string ) Reports the locale that determines character classifications. See Section

Chapter 43. PL/Perl - Perl Procedural Language

database, use CREATE EXTENSION plperl , or from the shell command line use createlang plperl dbname

REINDEX

DATABASE Recreate all indexes within the current database. Indexes on shared system catalogs are also

19.11. Client Connection Defaults

database. If a nondefault tablespace is specified, the user must have CREATE privilege for it, or creation

createlang

created databases as well. See Also droplang , CREATE EXTENSION , CREATE LANGUAGE Prev   Up   Next createdb

pgbench

database sessions. The default TPC-B-like transaction test requires specific tables to be set up beforehand. pgbench should be invoked with the -i (initialize) option to create

23.2. Collation Support

database cannot be changed after its creation. 23.2.1. Concepts Conceptually, every expression of a collatable

Part III. Server Administration

Creating a Database Cluster 18.3. Starting the Database Server 18.4. Managing Kernel Resources 18.5. Shutting